A Tool for Data Warehouse Multidimensional Schema Design using Ontology
نویسندگان
چکیده
The data warehouse has become a necessary component for an effective analysis of large businesses. It is widely accepted that the data warehouse must be structured according to the multidimensional model to facilitate OLAP analysis. The two driving force for the design of a multidimensional model are data source and business requirements. In recent years in addition to operational databases, web data has become an important source for data warehouse. The web data may be semi-structured or unstructured and exhibit several heterogeneity issues. Hence the design of multidimensional model has become a tedious task. The use of semantic web technologies such as ontology helps to represent such web data into coherent information which can be incorporated in a data Warehouse. Ontology also helps to represent the business requirements in a formal way, which need to be used during the design. In this paper we present an ontology driven tool which helps to automatically derive the conceptual model and logical model for the data warehouse from data source and business requirements. We make use of ontology and its reasoning capabilities at various stages of our tool to facilitate the design task.
منابع مشابه
An Ontology based Hybrid Approach to Derive Multidimensional Schema for Data Warehouse
Due to the diversity of data source data integration has become a challenging task. Data warehouse system plays a vital role to integrate the data for making important business decisions. Data within the data warehouse is arranged as multidimensional schema. In past many works exist to carry out the design of the multidimensional schema for data warehouse from either requirements and/or data so...
متن کاملData Warehouse Schema Evolution and Adaptation Framework Using Ontology
Data Warehouse systems aim at integrating data from multiple heterogeneous, distributed, autonomous data sources. Due to changing business needs the data warehouse systems are never meant to be static. Changes in the data source structure or business requirements would result in the evolution of data warehouse schema structure. When data warehouse schema evolves the dependent modules such as it...
متن کاملAn Approach for Generating an XML Data Warehouse Schema using Model Transformation Language
Traditionally, the multidimensional schema of the data warehouse is derived from data sources that are mainly the company’s internal data, well-known and structured, by identifying facts, dimensions and numeric measurements through a manual analysis of the operational schemas. With the proliferation of new platforms of communication in today’s information societies, there has been growing numbe...
متن کاملAn Ontological Approach to Handle Multidimensional Schema Evolution for Data Warehouse
In recent years, the number of digital information storage and retrieval systems has increased immensely. Data warehousing has been found to be an extremely useful technology for integrating such heterogeneous and autonomous information sources. Data within the data warehouse is modelled in the form of a star or snowflake schema which facilitates business analysis in a multidimensional perspect...
متن کاملIntegrating XML Sources into a Data Warehouse
Since XML has become a standard for data exchange over the Internet, especially in B2B and B2C communication, there is an increasing need of integrating XML data into data warehousing systems. In this paper we propose a methodology for data warehouse design, when data sources are XML Schemas and conforming XML documents. Particular relevance is given to the conceptual and logical multidimension...
متن کامل